CREATE TABLE [dbo].[JOL_Require]
(
[JOL_Require_ID] [int] NOT NULL IDENTITY(1, 1),
[JOL_Require_Company] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_Job] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_Work_Area] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_Study_Level] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_Profession] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_Number] [int] NULL,
[JOL_Require_GetJob_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_Linkman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_Contact] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_EndTime] [datetime] NULL,
[JOL_Require_Requirement] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_AddUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_AddTime] [datetime] NULL,
[JOL_Require_UpdateTime] [datetime] NULL,
[JOL_Require_UpdateUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_VerifyTime] [datetime] NULL,
[JOL_Require_VerifyStatus] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Requi__JOL_R__30441BD6] DEFAULT ('未审核'),
[JOL_Require_VerifyUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Require_IsSendEmail] [bit] NULL CONSTRAINT [DF__JOL_Requi__JOL_R__3138400F] DEFAULT ((1)),
[JOL_Require_Student_Type] [int] NULL,
[JOL_Require_ClickNumber] [int] NULL,
[OnlyForSysu] [bit] NULL CONSTRAINT [DF__JOL_Requi__OnlyF__1C281490] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Require] ADD CONSTRAINT [PK__JOL_Require__2F4FF79D] PRIMARY KEY CLUSTERED  ([JOL_Require_ID]) ON [PRIMARY]
GO
